﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using QLHXNK.DataAccess;

namespace QLHXNK.BusinessLogic
{
    class Monthly_Expenses
    {
        #region --------------------------------------------Thêm, Xoá, Sửa-----------------------------------------
        //Thêm:
        public static int Insert(String month_name, String expenses_id, String amount, String remark)
        {
            return Monthly_ExpensesData.Insert(month_name, expenses_id, amount, remark);
        }

        #region Kiểm tra tồn tại
        public static int Existed(String monthName, String expensesID)
        {
          return  Monthly_ExpensesData.Existed( monthName, expensesID);
        }
        #endregion
        //Xóa:
        public static int Delete(int ID)
        {
            return Monthly_ExpensesData.Delete(ID);
        }
        public static int Delete(String monthName)
        {
            return Monthly_ExpensesData.Delete(monthName);
        }
        //Sửa:
        public static int Update(int ID, String month_name, String expenses_id, String amount, String remark)
        {
            return Monthly_ExpensesData.Update(ID, month_name, expenses_id, amount, remark);
        }
        #endregion

        #region -----------------------------------------Lấy danh sách----------------------------------
        public static DataTable getMonthly_ExpensesList(String strSQL)
        {
            return Monthly_ExpensesData.getMonthly_ExpensesList(strSQL);
        }
        #endregion
    }
}
